/*
This is the script that will be used to migrate the database from revision 10 to revision 12.

You can customize the script, and your edits will be used in deployment.
The following objects will be affected:
  agency.ConfigurationType
*/

SET NUMERIC_ROUNDABORT OFF
GO
SET ANSI_PADDING, ANSI_WARNINGS, CONCAT_NULL_YIELDS_NULL, ARITHABORT, QUOTED_IDENTIFIER, ANSI_NULLS ON
GO
PRINT N'Adding foreign keys to [agency].[ConfigurationType]'
GO
ALTER TABLE [agency].[ConfigurationType] ADD CONSTRAINT [FK_ConfigurationType_ConfigurationType] FOREIGN KEY ([ParentConfigurationTypeId]) REFERENCES [agency].[ConfigurationType] ([ConfigurationTypeId])
GO
